package util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class TestBoneCP {
	public static void main(String[] args) throws Exception {
		PreparedStatement pt = null;
		ResultSet rs = null;
		String sql = "";
		Connection conn = null;
		try {
			conn=Configurations.getInstance().getConnection();
			sql = "select * from tb_Module";
			pt = conn.prepareStatement(sql);
			rs = pt.executeQuery();
			while(rs.next()) {
				System.out.println(rs.getString(1)+"|"+rs.getString(2)+"|"+rs.getString(3));
			}// end if

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			Configurations.free(conn);
		}
	}

}
